Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 43206 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 5.6 MiB |
| Average record size in memory | 136.0 B |
Variable types
| Categorical | 4 |
|---|---|
| Numeric | 13 |
datum has a high cardinality: 532 distinct values | High cardinality |
häst has a high cardinality: 10235 distinct values | High cardinality |
dist is highly correlated with lopp_dist | High correlation |
lopp_dist is highly correlated with dist | High correlation |
dist is highly correlated with lopp_dist | High correlation |
lopp_dist is highly correlated with dist | High correlation |
dist is highly correlated with lopp_dist | High correlation |
lopp_dist is highly correlated with dist | High correlation |
dist is highly correlated with lopp_dist | High correlation |
lopp_dist is highly correlated with dist and 1 other fields | High correlation |
start is highly correlated with lopp_dist | High correlation |
delta3 is highly skewed (γ1 = 112.9965609) | Skewed |
datum is uniformly distributed | Uniform |
streck has 5157 (11.9%) zeros | Zeros |
Reproduction
| Analysis started | 2022-01-06 13:19:38.178858 |
|---|---|
| Analysis finished | 2022-01-06 13:20:07.399068 |
| Duration | 29.22 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 532 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 337.7 KiB |
| 2021-02-13 | 100 |
|---|---|
| 2020-02-01 | 98 |
| 2018-02-24 | 96 |
| 2019-02-09 | 96 |
| 2020-04-11 | 93 |
| Other values (527) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2014-12-28 |
|---|---|
| 2nd row | 2014-12-28 |
| 3rd row | 2014-12-28 |
| 4th row | 2014-12-28 |
| 5th row | 2014-12-28 |
Common Values
| Value | Count | Frequency (%) |
| 2021-02-13 | 100 | 0.2% |
| 2020-02-01 | 98 | 0.2% |
| 2018-02-24 | 96 | 0.2% |
| 2019-02-09 | 96 | 0.2% |
| 2020-04-11 | 93 | 0.2% |
| 2020-12-31 | 92 | 0.2% |
| 2019-09-29 | 91 | 0.2% |
| 2019-03-31 | 91 | 0.2% |
| 2019-12-25 | 91 | 0.2% |
| 2016-12-25 | 91 | 0.2% |
| Other values (522) | 42267 |
Length
| Value | Count | Frequency (%) |
| 2021-02-13 | 100 | 0.2% |
| 2020-02-01 | 98 | 0.2% |
| 2018-02-24 | 96 | 0.2% |
| 2019-02-09 | 96 | 0.2% |
| 2020-04-11 | 93 | 0.2% |
| 2020-12-31 | 92 | 0.2% |
| 2019-09-29 | 91 | 0.2% |
| 2019-03-31 | 91 | 0.2% |
| 2019-12-25 | 91 | 0.2% |
| 2016-12-25 | 91 | 0.2% |
| Other values (522) | 42267 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
avd
Real number (ℝ≥0)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.009165394 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 337.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.987184787 |
|---|---|
| Coefficient of variation (CV) | 0.495660466 |
| Kurtosis | -1.235141703 |
| Mean | 4.009165394 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.000829507796 |
| Sum | 173220 |
| Variance | 3.948903379 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 6629 | |
| 2 | 6432 | |
| 5 | 6156 | |
| 7 | 6155 | |
| 6 | 6093 | |
| 1 | 5903 | |
| 3 | 5838 |
| Value | Count | Frequency (%) |
| 1 | 5903 | |
| 2 | 6432 | |
| 3 | 5838 | |
| 4 | 6629 | |
| 5 | 6156 | |
| 6 | 6093 | |
| 7 | 6155 |
| Value | Count | Frequency (%) |
| 7 | 6155 | |
| 6 | 6093 | |
| 5 | 6156 | |
| 4 | 6629 | |
| 3 | 5838 | |
| 2 | 6432 | |
| 1 | 5903 |
| Distinct | 10235 |
|---|---|
| Distinct (%) | 23.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 337.7 KiB |
| ON TRACK PIRATEN | 91 |
|---|---|
| SUPER ZANTOS | 62 |
| WEST WING | 61 |
| ZENIT BRICK | 55 |
| DISCO VOLANTE | 55 |
| Other values (10230) |
Length
| Max length | 23 |
|---|---|
| Median length | 12 |
| Mean length | 11.82803314 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 3838 ? |
|---|---|
| Unique (%) | 8.9% |
Sample
| 1st row | ALLABALLAKAITOZ |
|---|---|
| 2nd row | ARISTOCAT BOKO |
| 3rd row | ART ON LINE |
| 4th row | BEAR DANCER |
| 5th row | BY AIR |
Common Values
| Value | Count | Frequency (%) |
| ON TRACK PIRATEN | 91 | 0.2% |
| SUPER ZANTOS | 62 | 0.1% |
| WEST WING | 61 | 0.1% |
| ZENIT BRICK | 55 | 0.1% |
| DISCO VOLANTE | 55 | 0.1% |
| MILLIGAN'S SCHOOL | 54 | 0.1% |
| NADAL BROLINE | 54 | 0.1% |
| VÄSTERBOONTHENEWS | 52 | 0.1% |
| NAROLD VOX | 52 | 0.1% |
| LINUS BOY | 49 | 0.1% |
| Other values (10225) | 42621 |
Length
| Value | Count | Frequency (%) |
| boko | 939 | 1.1% |
| face | 888 | 1.0% |
| global | 633 | 0.7% |
| am | 462 | 0.5% |
| the | 454 | 0.5% |
| kronos | 443 | 0.5% |
| sisu | 427 | 0.5% |
| de | 383 | 0.5% |
| mellby | 373 | 0.4% |
| of | 354 | 0.4% |
| Other values (9443) | 79506 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 91 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.543651345 |
| Minimum | 0 |
|---|---|
| Maximum | 90 |
| Zeros | 5157 |
| Zeros (%) | 11.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 337.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 4 |
| Q3 | 11 |
| 95-th percentile | 33 |
| Maximum | 90 |
| Range | 90 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 11.81744915 |
|---|---|
| Coefficient of variation (CV) | 1.383184856 |
| Kurtosis | 8.504183923 |
| Mean | 8.543651345 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 2.615625552 |
| Sum | 369137 |
| Variance | 139.6521045 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 7649 | |
| 0 | 5157 | |
| 2 | 4640 | 10.7% |
| 3 | 3252 | 7.5% |
| 4 | 2469 | 5.7% |
| 5 | 1915 | 4.4% |
| 6 | 1740 | 4.0% |
| 7 | 1439 | 3.3% |
| 8 | 1237 | 2.9% |
| 9 | 1047 | 2.4% |
| Other values (81) | 12661 |
| Value | Count | Frequency (%) |
| 0 | 5157 | |
| 1 | 7649 | |
| 2 | 4640 | |
| 3 | 3252 | |
| 4 | 2469 | 5.7% |
| 5 | 1915 | 4.4% |
| 6 | 1740 | 4.0% |
| 7 | 1439 | 3.3% |
| 8 | 1237 | 2.9% |
| 9 | 1047 | 2.4% |
| Value | Count | Frequency (%) |
| 90 | 3 | < 0.1% |
| 89 | 4 | |
| 88 | 4 | |
| 87 | 6 | |
| 86 | 6 | |
| 85 | 4 | |
| 84 | 3 | < 0.1% |
| 83 | 4 | |
| 82 | 4 | |
| 81 | 8 |
kr
Real number (ℝ≥0)
| Distinct | 26753 |
|---|---|
| Distinct (%) | 61.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28363.3917 |
| Minimum | 0 |
|---|---|
| Maximum | 806743 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 337.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5788.25 |
| Q1 | 10756.25 |
| median | 17007 |
| Q3 | 29091.75 |
| 95-th percentile | 90072.75 |
| Maximum | 806743 |
| Range | 806743 |
| Interquartile range (IQR) | 18335.5 |
Descriptive statistics
| Standard deviation | 39653.00173 |
|---|---|
| Coefficient of variation (CV) | 1.398034556 |
| Kurtosis | 50.10442242 |
| Mean | 28363.3917 |
| Median Absolute Deviation (MAD) | 7727 |
| Skewness | 5.681766626 |
| Sum | 1225468702 |
| Variance | 1572360546 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20000 | 17 | < 0.1% |
| 25000 | 14 | < 0.1% |
| 17000 | 14 | < 0.1% |
| 27500 | 13 | < 0.1% |
| 24000 | 13 | < 0.1% |
| 19000 | 13 | < 0.1% |
| 17500 | 13 | < 0.1% |
| 22500 | 13 | < 0.1% |
| 12250 | 12 | < 0.1% |
| 14500 | 12 | < 0.1% |
| Other values (26743) | 43072 |
| Value | Count | Frequency (%) |
| 0 | 3 | |
| 783 | 1 | < 0.1% |
| 1066 | 1 | < 0.1% |
| 1135 | 1 | < 0.1% |
| 1270 | 1 | < 0.1% |
| 1297 | 1 | < 0.1% |
| 1425 | 1 | < 0.1% |
| 1475 | 1 | < 0.1% |
| 1479 | 1 | < 0.1% |
| 1686 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 806743 | 1 | |
| 799864 | 1 | |
| 773414 | 1 | |
| 637821 | 1 | |
| 619767 | 1 | |
| 605142 | 1 | |
| 601348 | 1 | |
| 599418 | 1 | |
| 595989 | 1 | |
| 573125 | 1 |
spår
Real number (ℝ≥0)
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.691802065 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 89 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 337.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.400409229 |
|---|---|
| Coefficient of variation (CV) | 0.5974222558 |
| Kurtosis | -0.9558507376 |
| Mean | 5.691802065 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.3412506648 |
| Sum | 245920 |
| Variance | 11.56278293 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 4869 | |
| 2 | 4627 | |
| 3 | 4578 | |
| 4 | 4349 | |
| 5 | 3945 | |
| 6 | 3846 | |
| 7 | 3472 | |
| 9 | 3129 | |
| 10 | 2880 | |
| 8 | 2671 | |
| Other values (6) | 4840 |
| Value | Count | Frequency (%) |
| 0 | 89 | 0.2% |
| 1 | 4869 | |
| 2 | 4627 | |
| 3 | 4578 | |
| 4 | 4349 | |
| 5 | 3945 | |
| 6 | 3846 | |
| 7 | 3472 | |
| 8 | 2671 | |
| 9 | 3129 |
| Value | Count | Frequency (%) |
| 15 | 109 | 0.3% |
| 14 | 122 | 0.3% |
| 13 | 133 | 0.3% |
| 12 | 1904 | |
| 11 | 2483 | |
| 10 | 2880 | |
| 9 | 3129 | |
| 8 | 2671 | |
| 7 | 3472 | |
| 6 | 3846 |
| Distinct | 48 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2187.699787 |
| Minimum | 1600 |
|---|---|
| Maximum | 3700 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 337.7 KiB |
Quantile statistics
| Minimum | 1600 |
|---|---|
| 5-th percentile | 1640 |
| Q1 | 2120 |
| median | 2140 |
| Q3 | 2160 |
| 95-th percentile | 3140 |
| Maximum | 3700 |
| Range | 2100 |
| Interquartile range (IQR) | 40 |
Descriptive statistics
| Standard deviation | 393.6790235 |
|---|---|
| Coefficient of variation (CV) | 0.1799511184 |
| Kurtosis | 0.6173047981 |
| Mean | 2187.699787 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | 0.7284415231 |
| Sum | 94521757 |
| Variance | 154983.1735 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2140 | 19726 | |
| 1640 | 5870 | 13.6% |
| 2640 | 5414 | 12.5% |
| 2160 | 2554 | 5.9% |
| 2100 | 2024 | 4.7% |
| 1609 | 1896 | 4.4% |
| 3140 | 1172 | 2.7% |
| 2660 | 753 | 1.7% |
| 3160 | 715 | 1.7% |
| 2000 | 522 | 1.2% |
| Other values (38) | 2560 | 5.9% |
| Value | Count | Frequency (%) |
| 1600 | 76 | 0.2% |
| 1609 | 1896 | 4.4% |
| 1640 | 5870 | |
| 1646 | 10 | < 0.1% |
| 1660 | 244 | 0.6% |
| 1680 | 14 | < 0.1% |
| 1800 | 64 | 0.1% |
| 2000 | 522 | 1.2% |
| 2011 | 58 | 0.1% |
| 2020 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 3700 | 7 | < 0.1% |
| 3680 | 14 | < 0.1% |
| 3660 | 22 | 0.1% |
| 3640 | 24 | 0.1% |
| 3220 | 17 | < 0.1% |
| 3200 | 76 | 0.2% |
| 3180 | 516 | |
| 3160 | 715 | |
| 3140 | 1172 | |
| 3120 | 78 | 0.2% |
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2184.22527 |
| Minimum | 1600 |
|---|---|
| Maximum | 3640 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 337.7 KiB |
Quantile statistics
| Minimum | 1600 |
|---|---|
| 5-th percentile | 1640 |
| Q1 | 2100 |
| median | 2140 |
| Q3 | 2140 |
| 95-th percentile | 3140 |
| Maximum | 3640 |
| Range | 2040 |
| Interquartile range (IQR) | 40 |
Descriptive statistics
| Standard deviation | 390.5266046 |
|---|---|
| Coefficient of variation (CV) | 0.1787941061 |
| Kurtosis | 0.5671308319 |
| Mean | 2184.22527 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.7100259929 |
| Sum | 94371637 |
| Variance | 152511.0289 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2140 | 22751 | |
| 2640 | 6326 | 14.6% |
| 1640 | 6128 | 14.2% |
| 3140 | 2385 | 5.5% |
| 2100 | 2037 | 4.7% |
| 1609 | 1896 | 4.4% |
| 2000 | 545 | 1.3% |
| 2600 | 199 | 0.5% |
| 3100 | 185 | 0.4% |
| 2950 | 125 | 0.3% |
| Other values (13) | 629 | 1.5% |
| Value | Count | Frequency (%) |
| 1600 | 76 | 0.2% |
| 1609 | 1896 | 4.4% |
| 1640 | 6128 | 14.2% |
| 1646 | 10 | < 0.1% |
| 1800 | 64 | 0.1% |
| 2000 | 545 | 1.3% |
| 2011 | 58 | 0.1% |
| 2100 | 2037 | 4.7% |
| 2120 | 23 | 0.1% |
| 2140 | 22751 |
| Value | Count | Frequency (%) |
| 3640 | 67 | 0.2% |
| 3140 | 2385 | 5.5% |
| 3120 | 63 | 0.1% |
| 3100 | 185 | 0.4% |
| 3000 | 48 | 0.1% |
| 2950 | 125 | 0.3% |
| 2900 | 26 | 0.1% |
| 2880 | 13 | < 0.1% |
| 2650 | 24 | 0.1% |
| 2640 | 6326 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 337.7 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 30104 | |
| 1 | 13102 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 30104 | |
| 1 | 13102 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
kön
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 337.7 KiB |
| v | |
|---|---|
| s | |
| h |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | v |
|---|---|
| 2nd row | v |
| 3rd row | v |
| 4th row | v |
| 5th row | v |
Common Values
| Value | Count | Frequency (%) |
| v | 21057 | |
| s | 11313 | |
| h | 10836 |
Length
Pie chart
| Value | Count | Frequency (%) |
| v | 21057 | |
| s | 11313 | |
| h | 10836 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
ålder
Real number (ℝ≥0)
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.812317734 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 6 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 337.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 5 |
| Q3 | 7 |
| 95-th percentile | 10 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.922386433 |
|---|---|
| Coefficient of variation (CV) | 0.3307435211 |
| Kurtosis | 1.224132744 |
| Mean | 5.812317734 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.002909639 |
| Sum | 251127 |
| Variance | 3.695569598 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 10435 | |
| 4 | 8976 | |
| 6 | 8336 | |
| 7 | 5404 | |
| 8 | 3354 | 7.8% |
| 3 | 2531 | 5.9% |
| 9 | 1831 | 4.2% |
| 10 | 1127 | 2.6% |
| 11 | 594 | 1.4% |
| 12 | 312 | 0.7% |
| Other values (5) | 306 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 6 | < 0.1% |
| 2 | 113 | 0.3% |
| 3 | 2531 | 5.9% |
| 4 | 8976 | |
| 5 | 10435 | |
| 6 | 8336 | |
| 7 | 5404 | |
| 8 | 3354 | 7.8% |
| 9 | 1831 | 4.2% |
| 10 | 1127 | 2.6% |
| Value | Count | Frequency (%) |
| 15 | 23 | 0.1% |
| 14 | 49 | 0.1% |
| 13 | 115 | 0.3% |
| 12 | 312 | 0.7% |
| 11 | 594 | 1.4% |
| 10 | 1127 | 2.6% |
| 9 | 1831 | 4.2% |
| 8 | 3354 | |
| 7 | 5404 | |
| 6 | 8336 |
pris
Real number (ℝ≥0)
| Distinct | 137 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 174481.5374 |
| Minimum | 0 |
|---|---|
| Maximum | 2000000 |
| Zeros | 391 |
| Zeros (%) | 0.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 337.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 100000 |
| median | 110000 |
| Q3 | 150000 |
| 95-th percentile | 550000 |
| Maximum | 2000000 |
| Range | 2000000 |
| Interquartile range (IQR) | 50000 |
Descriptive statistics
| Standard deviation | 226942.001 |
|---|---|
| Coefficient of variation (CV) | 1.30066484 |
| Kurtosis | 26.21582035 |
| Mean | 174481.5374 |
| Median Absolute Deviation (MAD) | 15000 |
| Skewness | 4.605041541 |
| Sum | 7538649304 |
| Variance | 5.15026718 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100000 | 12000 | |
| 125000 | 7307 | |
| 110000 | 4481 | 10.4% |
| 150000 | 3762 | 8.7% |
| 200000 | 3621 | 8.4% |
| 250000 | 1755 | 4.1% |
| 300000 | 767 | 1.8% |
| 220000 | 766 | 1.8% |
| 50000 | 742 | 1.7% |
| 1 | 571 | 1.3% |
| Other values (127) | 7434 |
| Value | Count | Frequency (%) |
| 0 | 391 | |
| 1 | 571 | |
| 2 | 297 | |
| 3 | 222 | 0.5% |
| 4 | 172 | 0.4% |
| 5 | 135 | 0.3% |
| 6 | 110 | 0.3% |
| 7 | 92 | 0.2% |
| 8 | 86 | 0.2% |
| 9 | 80 | 0.2% |
| Value | Count | Frequency (%) |
| 2000000 | 189 | 0.4% |
| 1953760 | 10 | < 0.1% |
| 1822944 | 12 | < 0.1% |
| 1609000 | 19 | < 0.1% |
| 1500000 | 98 | 0.2% |
| 1400000 | 70 | 0.2% |
| 1200000 | 47 | 0.1% |
| 1150000 | 24 | 0.1% |
| 1000000 | 532 | |
| 976880 | 23 | 0.1% |
senast
Real number (ℝ≥0)
| Distinct | 287 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.1539601 |
| Minimum | 0 |
|---|---|
| Maximum | 364 |
| Zeros | 15 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 337.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 12 |
| median | 15 |
| Q3 | 22 |
| 95-th percentile | 46 |
| Maximum | 364 |
| Range | 364 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 22.98094684 |
|---|---|
| Coefficient of variation (CV) | 1.086366181 |
| Kurtosis | 58.51501722 |
| Mean | 21.1539601 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 6.53741868 |
| Sum | 913978 |
| Variance | 528.1239175 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14 | 5288 | 12.2% |
| 21 | 2996 | 6.9% |
| 10 | 2675 | 6.2% |
| 11 | 2259 | 5.2% |
| 15 | 2203 | 5.1% |
| 13 | 2152 | 5.0% |
| 12 | 2028 | 4.7% |
| 17 | 1952 | 4.5% |
| 7 | 1777 | 4.1% |
| 9 | 1739 | 4.0% |
| Other values (277) | 18137 |
| Value | Count | Frequency (%) |
| 0 | 15 | < 0.1% |
| 3 | 7 | < 0.1% |
| 4 | 6 | < 0.1% |
| 5 | 21 | < 0.1% |
| 6 | 121 | 0.3% |
| 7 | 1777 | |
| 8 | 1515 | |
| 9 | 1739 | |
| 10 | 2675 | |
| 11 | 2259 |
| Value | Count | Frequency (%) |
| 364 | 1 | < 0.1% |
| 363 | 1 | < 0.1% |
| 353 | 1 | < 0.1% |
| 350 | 1 | < 0.1% |
| 349 | 1 | < 0.1% |
| 348 | 1 | < 0.1% |
| 343 | 1 | < 0.1% |
| 341 | 1 | < 0.1% |
| 337 | 3 | |
| 336 | 1 | < 0.1% |
delta1
Real number (ℝ≥0)
| Distinct | 365 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.16495394 |
| Minimum | 0 |
|---|---|
| Maximum | 750 |
| Zeros | 238 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 337.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 12 |
| median | 16 |
| Q3 | 24 |
| 95-th percentile | 72 |
| Maximum | 750 |
| Range | 750 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 34.29788409 |
|---|---|
| Coefficient of variation (CV) | 1.362922585 |
| Kurtosis | 52.06388749 |
| Mean | 25.16495394 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 5.941616662 |
| Sum | 1087277 |
| Variance | 1176.344853 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14 | 4429 | 10.3% |
| 21 | 2513 | 5.8% |
| 11 | 2319 | 5.4% |
| 10 | 2173 | 5.0% |
| 13 | 2051 | 4.7% |
| 15 | 2025 | 4.7% |
| 12 | 1914 | 4.4% |
| 7 | 1761 | 4.1% |
| 17 | 1719 | 4.0% |
| 18 | 1552 | 3.6% |
| Other values (355) | 20750 |
| Value | Count | Frequency (%) |
| 0 | 238 | 0.6% |
| 1 | 13 | < 0.1% |
| 2 | 5 | < 0.1% |
| 3 | 64 | 0.1% |
| 4 | 86 | 0.2% |
| 5 | 173 | 0.4% |
| 6 | 382 | 0.9% |
| 7 | 1761 | |
| 8 | 1335 | |
| 9 | 1502 |
| Value | Count | Frequency (%) |
| 750 | 1 | |
| 669 | 2 | |
| 638 | 1 | |
| 606 | 1 | |
| 566 | 1 | |
| 529 | 1 | |
| 502 | 1 | |
| 494 | 1 | |
| 492 | 1 | |
| 478 | 1 |
delta2
Real number (ℝ≥0)
| Distinct | 413 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.48039624 |
| Minimum | 0 |
|---|---|
| Maximum | 1918 |
| Zeros | 221 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 337.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 12 |
| median | 16 |
| Q3 | 24 |
| 95-th percentile | 80 |
| Maximum | 1918 |
| Range | 1918 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 41.78708879 |
|---|---|
| Coefficient of variation (CV) | 1.578038652 |
| Kurtosis | 238.2780869 |
| Mean | 26.48039624 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 10.25221281 |
| Sum | 1144112 |
| Variance | 1746.160789 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14 | 4268 | 9.9% |
| 21 | 2430 | 5.6% |
| 11 | 2306 | 5.3% |
| 13 | 2180 | 5.0% |
| 10 | 2156 | 5.0% |
| 15 | 1996 | 4.6% |
| 12 | 1867 | 4.3% |
| 7 | 1825 | 4.2% |
| 17 | 1819 | 4.2% |
| 16 | 1595 | 3.7% |
| Other values (403) | 20764 |
| Value | Count | Frequency (%) |
| 0 | 221 | 0.5% |
| 1 | 14 | < 0.1% |
| 2 | 6 | < 0.1% |
| 3 | 48 | 0.1% |
| 4 | 96 | 0.2% |
| 5 | 157 | 0.4% |
| 6 | 413 | 1.0% |
| 7 | 1825 | |
| 8 | 1308 | |
| 9 | 1507 |
| Value | Count | Frequency (%) |
| 1918 | 1 | |
| 1707 | 1 | |
| 1154 | 1 | |
| 923 | 1 | |
| 900 | 1 | |
| 869 | 1 | |
| 868 | 1 | |
| 830 | 1 | |
| 806 | 1 | |
| 790 | 1 |
| Distinct | 412 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.3095172 |
| Minimum | 0 |
|---|---|
| Maximum | 12343 |
| Zeros | 268 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 337.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 12 |
| median | 16 |
| Q3 | 25 |
| 95-th percentile | 86 |
| Maximum | 12343 |
| Range | 12343 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 73.00619524 |
|---|---|
| Coefficient of variation (CV) | 2.673287657 |
| Kurtosis | 18768.53172 |
| Mean | 27.3095172 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 112.9965609 |
| Sum | 1179935 |
| Variance | 5329.904544 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14 | 4195 | 9.7% |
| 21 | 2386 | 5.5% |
| 11 | 2281 | 5.3% |
| 13 | 2132 | 4.9% |
| 10 | 2129 | 4.9% |
| 15 | 1932 | 4.5% |
| 12 | 1859 | 4.3% |
| 7 | 1802 | 4.2% |
| 17 | 1680 | 3.9% |
| 16 | 1602 | 3.7% |
| Other values (402) | 21208 |
| Value | Count | Frequency (%) |
| 0 | 268 | 0.6% |
| 1 | 11 | < 0.1% |
| 2 | 6 | < 0.1% |
| 3 | 65 | 0.2% |
| 4 | 96 | 0.2% |
| 5 | 178 | 0.4% |
| 6 | 410 | 0.9% |
| 7 | 1802 | |
| 8 | 1351 | |
| 9 | 1574 |
| Value | Count | Frequency (%) |
| 12343 | 1 | |
| 1918 | 1 | |
| 1707 | 1 | |
| 1246 | 1 | |
| 960 | 1 | |
| 812 | 1 | |
| 764 | 1 | |
| 756 | 1 | |
| 750 | 1 | |
| 728 | 1 |
delta4
Real number (ℝ≥0)
| Distinct | 422 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.41725686 |
| Minimum | 0 |
|---|---|
| Maximum | 1130 |
| Zeros | 323 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 337.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 12 |
| median | 16 |
| Q3 | 25 |
| 95-th percentile | 89 |
| Maximum | 1130 |
| Range | 1130 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 42.08231272 |
|---|---|
| Coefficient of variation (CV) | 1.53488414 |
| Kurtosis | 76.40869123 |
| Mean | 27.41725686 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 6.770800943 |
| Sum | 1184590 |
| Variance | 1770.921044 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14 | 4135 | 9.6% |
| 21 | 2335 | 5.4% |
| 11 | 2219 | 5.1% |
| 13 | 2120 | 4.9% |
| 10 | 2103 | 4.9% |
| 15 | 1943 | 4.5% |
| 12 | 1882 | 4.4% |
| 7 | 1756 | 4.1% |
| 17 | 1754 | 4.1% |
| 16 | 1588 | 3.7% |
| Other values (412) | 21371 |
| Value | Count | Frequency (%) |
| 0 | 323 | 0.7% |
| 1 | 17 | < 0.1% |
| 2 | 8 | < 0.1% |
| 3 | 65 | 0.2% |
| 4 | 114 | 0.3% |
| 5 | 193 | 0.4% |
| 6 | 424 | 1.0% |
| 7 | 1756 | |
| 8 | 1350 | |
| 9 | 1586 |
| Value | Count | Frequency (%) |
| 1130 | 1 | |
| 933 | 1 | |
| 923 | 1 | |
| 921 | 1 | |
| 859 | 1 | |
| 843 | 1 | |
| 771 | 1 | |
| 763 | 1 | |
| 758 | 1 | |
| 734 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| datum | avd | häst | streck | kr | spår | dist | lopp_dist | start | kön | ålder | pris | senast | delta1 | delta2 | delta3 | delta4 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2014-12-28 | 1 | ALLABALLAKAITOZ | 5.0 | 21018.0 | 6.0 | 2100.0 | 2100.0 | 0 | v | 6 | 125000.0 | 21.0 | 19.0 | 17.0 | 10.0 | 18.0 |
| 1 | 2014-12-28 | 1 | ARISTOCAT BOKO | 7.0 | 23466.0 | 12.0 | 2100.0 | 2100.0 | 0 | v | 7 | 125000.0 | 8.0 | 7.0 | 24.0 | 14.0 | 11.0 |
| 2 | 2014-12-28 | 1 | ART ON LINE | 23.0 | 20696.0 | 2.0 | 2100.0 | 2100.0 | 0 | v | 7 | 125000.0 | 9.0 | 6.0 | 19.0 | 41.0 | 15.0 |
| 3 | 2014-12-28 | 1 | BEAR DANCER | 48.0 | 27477.0 | 1.0 | 2100.0 | 2100.0 | 0 | v | 4 | 125000.0 | 18.0 | 25.0 | 14.0 | 13.0 | 8.0 |
| 4 | 2014-12-28 | 1 | BY AIR | 5.0 | 30589.0 | 5.0 | 2100.0 | 2100.0 | 0 | v | 7 | 125000.0 | 16.0 | 230.0 | 14.0 | 49.0 | 14.0 |
| 5 | 2014-12-28 | 1 | FREDRIK LADAY | 1.0 | 17496.0 | 8.0 | 2100.0 | 2100.0 | 0 | v | 6 | 125000.0 | 16.0 | 6.0 | 31.0 | 67.0 | 21.0 |
| 6 | 2014-12-28 | 1 | LADY LEE | 0.0 | 13805.0 | 7.0 | 2100.0 | 2100.0 | 0 | s | 7 | 125000.0 | 10.0 | 10.0 | 24.0 | 8.0 | 56.0 |
| 7 | 2014-12-28 | 1 | LORD ROCKET | 6.0 | 10191.0 | 3.0 | 2100.0 | 2100.0 | 0 | v | 9 | 125000.0 | 8.0 | 7.0 | 36.0 | 15.0 | 13.0 |
| 8 | 2014-12-28 | 1 | MAGNIFIK GELJ | 0.0 | 6650.0 | 11.0 | 2100.0 | 2100.0 | 0 | v | 9 | 125000.0 | 7.0 | 10.0 | 21.0 | 21.0 | 17.0 |
| 9 | 2014-12-28 | 1 | NAVIGATOR SIB | 1.0 | 14176.0 | 10.0 | 2100.0 | 2100.0 | 0 | v | 7 | 125000.0 | 8.0 | 15.0 | 16.0 | 18.0 | 9.0 |
Last rows
| datum | avd | häst | streck | kr | spår | dist | lopp_dist | start | kön | ålder | pris | senast | delta1 | delta2 | delta3 | delta4 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43196 | 2022-01-01 | 7 | SOUL TAN | 4.0 | 17569.0 | 3.0 | 2140.0 | 2140.0 | 0 | v | 7 | 4.0 | 17.0 | 87.0 | 11.0 | 37.0 | 19.0 |
| 43197 | 2022-01-01 | 7 | TALE OF JACKS | 11.0 | 15884.0 | 4.0 | 2140.0 | 2140.0 | 0 | h | 7 | 11.0 | 14.0 | 18.0 | 19.0 | 13.0 | 14.0 |
| 43198 | 2022-01-01 | 7 | LASS REVENUE | 4.0 | 12230.0 | 5.0 | 2140.0 | 2140.0 | 0 | v | 8 | 4.0 | 15.0 | 10.0 | 18.0 | 21.0 | 12.0 |
| 43199 | 2022-01-01 | 7 | ARCH LANE | 44.0 | 31680.0 | 6.0 | 2140.0 | 2140.0 | 0 | v | 8 | 44.0 | 14.0 | 11.0 | 37.0 | 17.0 | 13.0 |
| 43200 | 2022-01-01 | 7 | MELLBY HOFFA | 1.0 | 29092.0 | 7.0 | 2140.0 | 2140.0 | 0 | v | 6 | 1.0 | 13.0 | 10.0 | 53.0 | 135.0 | 5.0 |
| 43201 | 2022-01-01 | 7 | VICTORY TOPLINE | 6.0 | 22881.0 | 8.0 | 2140.0 | 2140.0 | 0 | v | 8 | 6.0 | 10.0 | 18.0 | 8.0 | 9.0 | 228.0 |
| 43202 | 2022-01-01 | 7 | AXL BROWN | 6.0 | 10576.0 | 9.0 | 2140.0 | 2140.0 | 0 | v | 8 | 6.0 | 22.0 | 22.0 | 27.0 | 13.0 | 9.0 |
| 43203 | 2022-01-01 | 7 | I'LL FIXIT | 1.0 | 10574.0 | 10.0 | 2140.0 | 2140.0 | 0 | v | 9 | 1.0 | 23.0 | 9.0 | 13.0 | 12.0 | 7.0 |
| 43204 | 2022-01-01 | 7 | BIG SHOT | 1.0 | 16593.0 | 11.0 | 2140.0 | 2140.0 | 0 | v | 6 | 1.0 | 15.0 | 14.0 | 14.0 | 12.0 | 23.0 |
| 43205 | 2022-01-01 | 7 | DOLLAR DOC | 6.0 | 34115.0 | 12.0 | 2140.0 | 2140.0 | 0 | v | 5 | 6.0 | 17.0 | 19.0 | 19.0 | 14.0 | 21.0 |